package com.softer.wxzj.entity;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;

/**
 * @author Gong Zhiyang
 * @date 2020/7/3
 */
@Data
public class ExcelBuilding {
    /**
     * 主键id
     * 生成报表时忽略，不生成次字段
     */
    @ExcelIgnore
    private String id;
    /**
     * 定义表头名称和位置,0代表第一列
     */
    @ExcelProperty(value = "单元", index = 0)
    private String cellName;
    @ExcelProperty(value = "楼层", index = 1)
    private String floorNo;
    @ExcelProperty(value = "房号", index = 2)
    private String roomNo;
    @ExcelProperty(value = "楼层属性", index = 3)
    private String buildType;
    @ExcelProperty(value = "结构属性", index = 4)
    private String buildAttr;
    @ExcelProperty(value = "有无电梯", index = 5)
    private String lift;
    @ExcelProperty(value = "承办银行", index = 6)
    private String bankCode;
    @ExcelProperty(value = "分区编号", index = 7)
    private String subRegionNo;
    @ExcelProperty(value = "房屋规则", index = 8)
    private String sortType;
    @ExcelProperty(value = "房屋性质", index = 9)
    private String houseUse;
    @ExcelProperty(value = "房屋类型", index = 10)
    private String houseAttr;
    @ExcelProperty(value = "交存模式", index = 11)
    private String firstMode;
    @ExcelProperty(value = "房屋面积", index = 12)
    private String struArea;
    @ExcelProperty(value = "业主姓名", index = 13)
    private String ownerName;
    @ExcelProperty(value = "联系方式", index = 14)
    private String phone;
    @ExcelProperty(value = "证件类型", index = 15)
    private String certType;
    @ExcelProperty(value = "证件号码", index = 16)
    private String certNo;
    @ExcelProperty(value = "购房售价", index = 17)
    private String price;
    @ExcelProperty(value = "购房日期", index = 18)
    private String purchaseDate;
    @ExcelProperty(value = "交存金额", index = 19)
    private String firstDue;
    @ExcelProperty(value = "交存日期", index = 20)
    private String reqDate;
    /**
     * 行政区域编码
     */
    private String zoneCode;
    /**
     * 小区ID
     */
    private String regionId;
    /**
     * 小区名称
     */
    private String regionName;
    /**
     * 自然幢名称
     */
    private String buildName;
    /**
     * 房间名称
     */
    private String roomName;
    /**
     * 位置
     */
    private String houseSite;
}
